SUPPORT / SAMPLES & SAS NOTES
Problem Note 52011: SAS® Financial Management Custom Analytics stored process fails with an append error
 |  |  |  |  |
A SAS Financial Management Custom Analytics stored process might fail due to inconsistent column lengths that are detected in an Append operation. An error similar to the following is displayed in the SAS® log:
NOTE: Appending WORK.MEMBER_CODES to WORK.COMMON_DTYPES. WARNING: Variable member_cd has different lengths on BASE and DATA files (BASE 32 DATA 192). ERROR: No appending done because of anomalies listed above. Use FORCE option to append these files.
Follow these steps to correct this problem:
- Download the ZIP file (SN52011.zip) from the Downloads tab of this SAS note.
- Back up the macros in the installation-directory:\Program Files\SASHome\SASFoundation\9.4\finance\sasmacro directory.
- Extract the contents of SN52011.zip to the same directory as in Step 2.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Financial Management | Linux for x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 |
| 64-bit Enabled Solaris | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| 64-bit Enabled AIX | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Ultimate x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Ultimate 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Professional x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Professional 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Home Premium x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Home Premium 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Enterprise x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Enterprise 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 Std | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 R2 Std | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 Datacenter | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Pro 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Pro | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Enterprise x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Pro x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Pro 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Enterprise x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Enterprise 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||